# from django.db import models
#
# class Department(models.Model):
#     """ 部门表 """
#     # id会自动创建
#     # id = models.AutoField(verbose_name="ID",primary_key=True)
#     # id = models.BigAutoField(verbose_name="ID",primary_key=True)
#     # title = models.CharField(max_length=16)
#     title = models.CharField(verbose_name="标题", max_length=64)
#
#     def __str__(self):
#         return self.title
#
# # Create your models here.
# class UserInfo(models.Model):
#     """ 员工表 """
#     name = models.CharField(verbose_name="姓名", max_length=32)
#     password = models.CharField(verbose_name="密码", max_length=64)
#     age = models.IntegerField(verbose_name="年龄", default=None)
#     account = models.DecimalField(verbose_name="账户余额", max_digits=10, decimal_places=2, default=None)
#     # creatime = models.DateTimeField()
#     creatime = models.DateField(verbose_name="入职时间")
#     gender_choice = (
#         (1,'男'),
#         (2,'女')
#     )
#     gender = models.SmallIntegerField(verbose_name="性别", choices=gender_choice)
#
#
#     # 无约束
#     # departMentId = models.BigIntegerField(verbose_name="部门ID")
#
#     # 1.有约束
#     #  - to：与哪张表关联
#     #  - to_field：表中的哪一列关联
#     # 2.Django自动
#     #  - 写的depart
#     #  - 生成数据库的列 depart_id
#     # 3.部门表被删除
#     #  3.1 级联删除
#     #    testdepart = models.ForeignKey(to="Department", to_field="id", on_delete=models.CASCADE)
#     #  3.2 置空
#     #    testdepart = models.ForeignKey(to="Department", to_field="id", null=True, blank=True, on_delete=models.SET_NULL)
#     depart = models.ForeignKey(verbose_name="部门", to="Department", to_field="id", null=True, blank=True, on_delete=models.SET_NULL)
#
#
# class PrettyNum(models.Model):
#     """ 靓号表 """
#     mobile = models.CharField(verbose_name="手机号", max_length=11)
#     # 想要参数允许为空，null=Ture,blank=Ture
#     price = models.IntegerField(verbose_name="价格", default=1)
#
#     level_choice = {
#         (1, "1级"),
#         (2, "2级"),
#         (3, "3级"),
#         (4, "4级"),
#     }
#     level = models.SmallIntegerField(verbose_name="级别", choices=level_choice, default=1)
#
#     ststus_choice = {
#         (1, "已占用"),
#         (2, "未使用"),
#     }
#     status = models.SmallIntegerField(verbose_name="状态", choices=ststus_choice, default=2)
#
# class Test_User(models.Model):
#     """ 员工表 """
#     name = models.CharField(verbose_name="姓名", max_length=32)
#     password = models.CharField(verbose_name="密码", max_length=64)
#     age = models.IntegerField(verbose_name="年龄", default=None)
#
#     class Meta:
#         db_table = "test_user"  # 自定义表名
#
#     def __str__(self):
#         return self.name
#
#
# # 本质：
# # """
# # create table tools_userinfo(
# #     id bigint auto_increment primary key,
# #     name varchar(32),
# #     password varchar(64),
# #     age int
# # )
# # """
#
# # 执行命令:
# # python manage.py makemigrations
# # python manage.py migrate
#
# # 删除表/字段：注掉代码，再执行上述命令
#
# # ########## 新建数据 ##########  代码写到views.py
# # 本质：insert into tools_department(title) values ("销售部");
# # Department.objects.create(title="销售部")
# # UserInfo.objects.create(name="zhangsan", password="123456", age=30)
#
#
